Model Data Profile Report

Dataset statistics

Number of variables	45
Number of observations	170023
Missing cells	81976
Missing cells (%)	1.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	57.2 MiB
Average record size in memory	353.0 B

Variable types

CAT	22
NUM	16
BOOL	7

Reproduction

Analysis started	2020-07-09 17:35:18.742143
Analysis finished	2020-07-09 17:36:43.297725
Duration	1 minute and 24.56 seconds
Version	pandas-profiling v2.8.0
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

Warnings

`STREET_NAME` has a high cardinality: 1341 distinct values	High cardinality
`BEAT_OF_OCCURRENCE` has a high cardinality: 271 distinct values	High cardinality
`LONGITUDE` is highly correlated with `LATITUDE`	High correlation
`LATITUDE` is highly correlated with `LONGITUDE`	High correlation
`MAIN_CAUSE` is highly correlated with `PRIM_CONTRIBUTORY_CAUSE`	High correlation
`PRIM_CONTRIBUTORY_CAUSE` is highly correlated with `MAIN_CAUSE`	High correlation
`LANE_TYPE` has 81976 (48.2%) missing values	Missing
`LATITUDE` is highly skewed (γ1 = -94.06388966)	Skewed
`LONGITUDE` is highly skewed (γ1 = 99.32443394)	Skewed
`df_index` has unique values	Unique
`CRASH_RECORD_ID` has unique values	Unique
`RD_NO` has unique values	Unique
`POSTED_SPEED_LIMIT` has 2351 (1.4%) zeros	Zeros
`INJURIES_TOTAL` has 147605 (86.8%) zeros	Zeros
`INJURIES_INCAPACITATING` has 167295 (98.4%) zeros	Zeros
`INJURIES_NON_INCAPACITATING` has 157578 (92.7%) zeros	Zeros
`INJURIES_REPORTED_NOT_EVIDENT` has 161617 (95.1%) zeros	Zeros
`INJURIES_NO_INDICATION` has 2783 (1.6%) zeros	Zeros
`CRASH_HOUR` has 2664 (1.6%) zeros	Zeros

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct count	170023
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	212170.16976526706
Minimum	6
Maximum	416193
Zeros	0
Zeros (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	6
5-th percentile	28454.4
Q1	110251
median	212739
Q3	314676.5
95-th percentile	395658.8
Maximum	416193
Range	416187
Interquartile range (IQR)	204425.5

Descriptive statistics

Standard deviation	118096.4642
Coefficient of variation (CV)	0.5566120079
Kurtosis	-1.191279946
Mean	212170.1698
Median Absolute Deviation (MAD)	102229
Skewness	-0.01242153214
Sum	3.607380877e+10
Variance	1.394677486e+10

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
264191	1	< 0.1%
77199	1	< 0.1%
69003	1	< 0.1%
335241	1	< 0.1%
71048	1	< 0.1%
332436	1	< 0.1%
353670	1	< 0.1%
97669	1	< 0.1%
95620	1	< 0.1%
83330	1	< 0.1%
Other values (170013)	170013	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
6	1	< 0.1%
8	1	< 0.1%
11	1	< 0.1%
12	1	< 0.1%
13	1	< 0.1%

Value	Count	Frequency (%)
416193	1	< 0.1%
416191	1	< 0.1%
416187	1	< 0.1%
416185	1	< 0.1%
416184	1	< 0.1%

CRASH_RECORD_ID
Categorical

UNIQUE

Distinct count	170023
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

0369378756c36e5cf3e326082c410ed564f44eed3b2bdd7c4569fd5434c10c5cd8c9eff26cee6ac80f9323612c8b05635d411d6811c8d58f51a32905a84b1a8f	1
65b898b3cd7fe07982a0961eafa7e15846934aab7bdefef1e4dd28223558766c75d54f743de04e9922a65205251a65cba98475c19b47728512f0ad6edac4b82d	1
b8308bbe775a21dc80a505c058af6c733a05c999500fb7778dfa6a1c69a8ddc45dff9b7bb930ac005dfade4ca520d9c32a55271d5c79d8da218d2eebe15d637f	1
8d912c9ef59f64ac63e12b9ce41a50177a7e4d458c194ccdc15fcaab4477d4e88b221912ae9dbc9ced56fd55cebb2fd46e2a10b6169e6512b9c6af8eb7807c04	1
8cb5dac0a8f4c6fbfb22a00021e2464e192acbfb54596c3485d4c348e902c066d66b55dadee3dd2463c6f4b010ffdbec69f34270c67e56746ff37945bd5c4c89	1
Other values (170018)	170018

Common Values
Length

Value	Count	Frequency (%)
0369378756c36e5cf3e326082c410ed564f44eed3b2bdd7c4569fd5434c10c5cd8c9eff26cee6ac80f9323612c8b05635d411d6811c8d58f51a32905a84b1a8f	1	< 0.1%
65b898b3cd7fe07982a0961eafa7e15846934aab7bdefef1e4dd28223558766c75d54f743de04e9922a65205251a65cba98475c19b47728512f0ad6edac4b82d	1	< 0.1%
b8308bbe775a21dc80a505c058af6c733a05c999500fb7778dfa6a1c69a8ddc45dff9b7bb930ac005dfade4ca520d9c32a55271d5c79d8da218d2eebe15d637f	1	< 0.1%
8d912c9ef59f64ac63e12b9ce41a50177a7e4d458c194ccdc15fcaab4477d4e88b221912ae9dbc9ced56fd55cebb2fd46e2a10b6169e6512b9c6af8eb7807c04	1	< 0.1%
8cb5dac0a8f4c6fbfb22a00021e2464e192acbfb54596c3485d4c348e902c066d66b55dadee3dd2463c6f4b010ffdbec69f34270c67e56746ff37945bd5c4c89	1	< 0.1%
2d2c0ab8950e029238e02e6ec4d8b83b614a557ee51bed49df04a1a364f060139a8b3c4ccd29599b71b0aeb54439f4e195b78b29ec3a3ac2c12e6beb784915c2	1	< 0.1%
e31dfcdb25c3d1a90b2fc9850a5f618601c6359fd1ebf915dcec0c36836ba0a09c926cf50fee2108c114c5bd0565e61ceed084f7192e2d9e21ebb66aff30531c	1	< 0.1%
a2957d935da9b3c8d7a6d447d3d60ef747bc37fb61dc4f3feaa36378737d0877c9b84f6e1aa48f731725a14dfd3976a5d17907027230ee1a8e4d10ac906e3a11	1	< 0.1%
a22e6631f1f17fe980b99a82f5db0eccb3175c02f6eb27b86e4133757c7349763e8f2a7d9958b7a20b17e888d503139eda30544f1460a9d3cf049a28bf9d132a	1	< 0.1%
fc93b7f28f4b387780c0c620734a58d168954d3208eceebc8d1c6d36616f796c864bbf35dabbca4341b90cc8e9feeef3b0d5d879b7a57749f916c8f52a0107ae	1	< 0.1%
Other values (170013)	170013	> 99.9%

Length

Max length	128
Median length	128
Mean length	128
Min length	128

RD_NO
Categorical

UNIQUE

Distinct count	170023
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

JC565912	1
JC428556	1
JA398424	1
JC174948	1
JB550813	1
Other values (170018)	170018

Common Values
Length

Value	Count	Frequency (%)
JC565912	1	< 0.1%
JC428556	1	< 0.1%
JA398424	1	< 0.1%
JC174948	1	< 0.1%
JB550813	1	< 0.1%
JA536780	1	< 0.1%
JC236142	1	< 0.1%
JC263315	1	< 0.1%
JC553659	1	< 0.1%
HZ548179	1	< 0.1%
Other values (170013)	170013	> 99.9%

Length

Max length	8
Median length	8
Mean length	8
Min length	8

POSTED_SPEED_LIMIT
Real number (ℝ_≥0)

ZEROS

Distinct count	14
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	28.67997270957459
Minimum	0.0
Maximum	70.0
Zeros	2351
Zeros (%)	1.4%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	15
Q1	30
median	30
Q3	30
95-th percentile	35
Maximum	70
Range	70
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	6.125015883
Coefficient of variation (CV)	0.2135642159
Kurtosis	8.292285248
Mean	28.67997271
Median Absolute Deviation (MAD)	0
Skewness	-2.307732956
Sum	4876255
Variance	37.51581957

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
30	129139	76.0%
35	12097	7.1%
25	8767	5.2%
20	5400	3.2%
15	5217	3.1%
10	2586	1.5%
0	2351	1.4%
40	1930	1.1%
45	1212	0.7%
5	1141	0.7%
Other values (4)	183	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2351	1.4%
5	1141	0.7%
10	2586	1.5%
15	5217	3.1%
20	5400	3.2%

Value	Count	Frequency (%)
70	1	< 0.1%
60	10	< 0.1%
55	137	0.1%
50	35	< 0.1%
45	1212	0.7%

TRAFFIC_CONTROL_DEVICE
Categorical

Distinct count	19
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

NO CONTROLS	88229
TRAFFIC SIGNAL	55468
STOP SIGN/FLASHER	20314
UNKNOWN	3110
OTHER	1026
Other values (14)	1876

Common Values
Length

Value	Count	Frequency (%)
NO CONTROLS	88229	51.9%
TRAFFIC SIGNAL	55468	32.6%
STOP SIGN/FLASHER	20314	11.9%
UNKNOWN	3110	1.8%
OTHER	1026	0.6%
LANE USE MARKING	629	0.4%
YIELD	309	0.2%
OTHER WARNING SIGN	218	0.1%
OTHER REG. SIGN	210	0.1%
RAILROAD CROSSING GATE	135	0.1%
Other values (9)	375	0.2%

Length

Max length	24
Median length	11
Mean length	12.62965011
Min length	5

DEVICE_CONDITION
Categorical

Distinct count	8
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

NO CONTROLS	89998
FUNCTIONING PROPERLY	70609
UNKNOWN	6243
OTHER	1360
FUNCTIONING IMPROPERLY	1117
Other values (3)	696

Common Values
Length

Value	Count	Frequency (%)
NO CONTROLS	89998	52.9%
FUNCTIONING PROPERLY	70609	41.5%
UNKNOWN	6243	3.7%
OTHER	1360	0.8%
FUNCTIONING IMPROPERLY	1117	0.7%
NOT FUNCTIONING	553	0.3%
WORN REFLECTIVE MATERIAL	114	0.1%
MISSING	29	< 0.1%

Length

Max length	24
Median length	11
Mean length	14.636061
Min length	5

WEATHER_CONDITION
Categorical

Distinct count	11
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

CLEAR	135513
RAIN	17503
SNOW	7254
CLOUDY/OVERCAST	6135
UNKNOWN	2174
Other values (6)	1444

Common Values
Length

Value	Count	Frequency (%)
CLEAR	135513	79.7%
RAIN	17503	10.3%
SNOW	7254	4.3%
CLOUDY/OVERCAST	6135	3.6%
UNKNOWN	2174	1.3%
OTHER	559	0.3%
FOG/SMOKE/HAZE	353	0.2%
SLEET/HAIL	306	0.2%
FREEZING RAIN/DRIZZLE	156	0.1%
SEVERE CROSS WIND GATE	46	< 0.1%

Length

Max length	22
Median length	5
Mean length	5.288749169
Min length	4

LIGHTING_CONDITION
Categorical

Distinct count	6
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

DAYLIGHT	117230
DARKNESS, LIGHTED ROAD	35379
DARKNESS	7452
DUSK	5267
DAWN	2971

Common Values
Length

Value	Count	Frequency (%)
DAYLIGHT	117230	68.9%
DARKNESS, LIGHTED ROAD	35379	20.8%
DARKNESS	7452	4.4%
DUSK	5267	3.1%
DAWN	2971	1.7%
UNKNOWN	1724	1.0%

Length

Max length	22
Median length	8
Mean length	10.70922169
Min length	4

FIRST_CRASH_TYPE
Categorical

Distinct count	18
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

REAR END	52403
SIDESWIPE SAME DIRECTION	31505
TURNING	23259
PARKED MOTOR VEHICLE	22195
ANGLE	22150
Other values (13)	18511

Common Values
Length

Value	Count	Frequency (%)
REAR END	52403	30.8%
SIDESWIPE SAME DIRECTION	31505	18.5%
TURNING	23259	13.7%
PARKED MOTOR VEHICLE	22195	13.1%
ANGLE	22150	13.0%
FIXED OBJECT	5461	3.2%
PEDESTRIAN	3566	2.1%
SIDESWIPE OPPOSITE DIRECTION	2569	1.5%
PEDALCYCLIST	2214	1.3%
HEAD ON	1613	0.9%
Other values (8)	3088	1.8%

Length

Max length	28
Median length	8
Mean length	12.60164801
Min length	5

TRAFFICWAY_TYPE
Categorical

Distinct count	20
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

NOT DIVIDED	76991
DIVIDED - W/MEDIAN (NOT RAISED)	35361
ONE-WAY	19075
DIVIDED - W/MEDIAN BARRIER	12003
PARKING LOT	9926
Other values (15)	16667

Common Values
Length

Value	Count	Frequency (%)
NOT DIVIDED	76991	45.3%
DIVIDED - W/MEDIAN (NOT RAISED)	35361	20.8%
ONE-WAY	19075	11.2%
DIVIDED - W/MEDIAN BARRIER	12003	7.1%
PARKING LOT	9926	5.8%
OTHER	4906	2.9%
FOUR WAY	4051	2.4%
ALLEY	2268	1.3%
CENTER TURN LANE	1733	1.0%
UNKNOWN	1092	0.6%
Other values (10)	2617	1.5%

Length

Max length	31
Median length	11
Mean length	15.47732366
Min length	4

ROADWAY_SURFACE_COND
Categorical

Distinct count	7
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

DRY	128493
WET	26900
SNOW OR SLUSH	6743
UNKNOWN	5774
ICE	1689
Other values (2)	424

Common Values
Length

Value	Count	Frequency (%)
DRY	128493	75.6%
WET	26900	15.8%
SNOW OR SLUSH	6743	4.0%
UNKNOWN	5774	3.4%
ICE	1689	1.0%
OTHER	335	0.2%
SAND, MUD, DIRT	89	0.1%

Length

Max length	15
Median length	3
Mean length	3.542655994
Min length	3

ROAD_DEFECT
Categorical

Distinct count	7
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

NO DEFECTS	146325
UNKNOWN	20131
RUT, HOLES	1242
OTHER	1052
WORN SURFACE	706
Other values (2)	567

Common Values
Length

Value	Count	Frequency (%)
NO DEFECTS	146325	86.1%
UNKNOWN	20131	11.8%
RUT, HOLES	1242	0.7%
OTHER	1052	0.6%
WORN SURFACE	706	0.4%
SHOULDER DEFECT	400	0.2%
DEBRIS ON ROADWAY	167	0.1%

Length

Max length	17
Median length	10
Mean length	9.640801539
Min length	5

REPORT_TYPE
Categorical

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

NOT ON SCENE (DESK REPORT)	98971
ON SCENE	71052

Common Values
Length

Value	Count	Frequency (%)
NOT ON SCENE (DESK REPORT)	98971	58.2%
ON SCENE	71052	41.8%

Length

Max length	26
Median length	26
Mean length	18.47786476
Min length	8

CRASH_TYPE
Categorical

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

NO INJURY / DRIVE AWAY	127310
INJURY AND / OR TOW DUE TO CRASH	42713

Common Values
Length

Value	Count	Frequency (%)
NO INJURY / DRIVE AWAY	127310	74.9%
INJURY AND / OR TOW DUE TO CRASH	42713	25.1%

Length

Max length	32
Median length	22
Mean length	24.51218953
Min length	22

HIT_AND_RUN_I
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

0	135422
1	34601

Frequency Table

Value	Count	Frequency (%)
0	135422	79.6%
1	34601	20.4%

DAMAGE
Categorical

Distinct count	3
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

OVER $1,500	99753
$501 - $1,500	48427
$500 OR LESS	21843

Common Values
Length

Value	Count	Frequency (%)
OVER $1,500	99753	58.7%
$501 - $1,500	48427	28.5%
$500 OR LESS	21843	12.8%

Length

Max length	13
Median length	11
Mean length	11.6981232
Min length	11

PRIM_CONTRIBUTORY_CAUSE
Categorical

HIGH CORRELATION

Distinct count	33
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

FOLLOWING TOO CLOSELY	36010
FAILING TO YIELD RIGHT-OF-WAY	35339
IMPROPER OVERTAKING/PASSING	15747
IMPROPER BACKING	14179
IMPROPER LANE USAGE	12920
Other values (28)	55828

Common Values
Length

Value	Count	Frequency (%)
FOLLOWING TOO CLOSELY	36010	21.2%
FAILING TO YIELD RIGHT-OF-WAY	35339	20.8%
IMPROPER OVERTAKING/PASSING	15747	9.3%
IMPROPER BACKING	14179	8.3%
IMPROPER LANE USAGE	12920	7.6%
FAILING TO REDUCE SPEED TO AVOID CRASH	12487	7.3%
DRIVING SKILLS/KNOWLEDGE/EXPERIENCE	9678	5.7%
WEATHER	5003	2.9%
DISREGARDING TRAFFIC SIGNALS	4822	2.8%
DISREGARDING STOP SIGN	3170	1.9%
Other values (23)	20668	12.2%

Length

Max length	80
Median length	27
Mean length	27.14715068
Min length	6

SEC_CONTRIBUTORY_CAUSE
Categorical

Distinct count	40
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

NOT APPLICABLE	64854
UNABLE TO DETERMINE	38816
FAILING TO REDUCE SPEED TO AVOID CRASH	12053
FOLLOWING TOO CLOSELY	8748
DRIVING SKILLS/KNOWLEDGE/EXPERIENCE	8659
Other values (35)	36893

Common Values
Length

Value	Count	Frequency (%)
NOT APPLICABLE	64854	38.1%
UNABLE TO DETERMINE	38816	22.8%
FAILING TO REDUCE SPEED TO AVOID CRASH	12053	7.1%
FOLLOWING TOO CLOSELY	8748	5.1%
DRIVING SKILLS/KNOWLEDGE/EXPERIENCE	8659	5.1%
FAILING TO YIELD RIGHT-OF-WAY	8461	5.0%
IMPROPER OVERTAKING/PASSING	4279	2.5%
IMPROPER LANE USAGE	3873	2.3%
WEATHER	3578	2.1%
IMPROPER BACKING	2615	1.5%
Other values (30)	14087	8.3%

Length

Max length	80
Median length	19
Mean length	21.33806603
Min length	6

STREET_NO
Real number (ℝ_≥0)

Distinct count	9237
Unique (%)	5.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3569.368708939379
Minimum	1.0
Maximum	13799.0
Zeros	0
Zeros (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	1
5-th percentile	128
Q1	1158
median	3100
Q3	5500
95-th percentile	8700
Maximum	13799
Range	13798
Interquartile range (IQR)	4342

Descriptive statistics

Standard deviation	2810.179625
Coefficient of variation (CV)	0.7873043817
Kurtosis	0.004114620722
Mean	3569.368709
Median Absolute Deviation (MAD)	2120
Skewness	0.7582665448
Sum	606874776
Variance	7897109.522

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
100	1282	0.8%
1600	1125	0.7%
200	1077	0.6%
300	1073	0.6%
800	1065	0.6%
500	1005	0.6%
2400	925	0.5%
600	905	0.5%
1200	890	0.5%
6300	884	0.5%
Other values (9227)	159792	94.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	635	0.4%
2	349	0.2%
3	64	< 0.1%
4	40	< 0.1%
5	93	0.1%

Value	Count	Frequency (%)
13799	1	< 0.1%
13770	5	< 0.1%
13758	1	< 0.1%
13756	1	< 0.1%
13755	1	< 0.1%

STREET_DIRECTION
Categorical

Distinct count	4
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

W	61742
S	54254
N	42646
E	11381

Common Values
Length

Value	Count	Frequency (%)
W	61742	36.3%
S	54254	31.9%
N	42646	25.1%
E	11381	6.7%

Length

Max length	1
Median length	1
Mean length	1
Min length	1

STREET_NAME
Categorical

HIGH CARDINALITY

Distinct count	1341
Unique (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

WESTERN AVE	4876
PULASKI RD	4295
CICERO AVE	4041
ASHLAND AVE	3806
HALSTED ST	3500
Other values (1336)	149505

Common Values
Length

Value	Count	Frequency (%)
WESTERN AVE	4876	2.9%
PULASKI RD	4295	2.5%
CICERO AVE	4041	2.4%
ASHLAND AVE	3806	2.2%
HALSTED ST	3500	2.1%
KEDZIE AVE	2884	1.7%
MICHIGAN AVE	2549	1.5%
STATE ST	2283	1.3%
CLARK ST	2241	1.3%
NORTH AVE	2125	1.2%
Other values (1331)	137423	80.8%

Length

Max length	27
Median length	10
Mean length	10.69305329
Min length	5

BEAT_OF_OCCURRENCE
Categorical

HIGH CARDINALITY

Distinct count	271
Unique (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

1834.0	2490
114.0	2363
122.0	2273
1831.0	1869
813.0	1690
Other values (266)	159338

Common Values
Length

Value	Count	Frequency (%)
1834.0	2490	1.5%
114.0	2363	1.4%
122.0	2273	1.3%
1831.0	1869	1.1%
813.0	1690	1.0%
815.0	1681	1.0%
2512.0	1424	0.8%
1622.0	1421	0.8%
833.0	1414	0.8%
834.0	1374	0.8%
Other values (261)	152024	89.4%

Length

Max length	6
Median length	6
Mean length	5.593560871
Min length	5

NUM_UNITS
Real number (ℝ_≥0)

Distinct count	12
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.0433000241143846
Minimum	1.0
Maximum	12.0
Zeros	0
Zeros (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	2
median	2
Q3	2
95-th percentile	3
Maximum	12
Range	11
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.3995417469
Coefficient of variation (CV)	0.1955374846
Kurtosis	33.41500969
Mean	2.043300024
Median Absolute Deviation (MAD)	0
Skewness	3.370232641
Sum	347408
Variance	0.1596336075

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2	152537	89.7%
3	9182	5.4%
1	6367	3.7%
4	1491	0.9%
5	313	0.2%
6	85	< 0.1%
7	21	< 0.1%
8	16	< 0.1%
9	7	< 0.1%
11	2	< 0.1%
Other values (2)	2	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	6367	3.7%
2	152537	89.7%
3	9182	5.4%
4	1491	0.9%
5	313	0.2%

Value	Count	Frequency (%)
12	1	< 0.1%
11	2	< 0.1%
10	1	< 0.1%
9	7	< 0.1%
8	16	< 0.1%

INJURIES_TOTAL
Real number (ℝ_≥0)

ZEROS

Distinct count	13
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.17885227292778036
Minimum	0.0
Maximum	13.0
Zeros	147605
Zeros (%)	86.8%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	13
Range	13
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.5395852213
Coefficient of variation (CV)	3.016932424
Kurtosis	31.08309577
Mean	0.1788522729
Median Absolute Deviation (MAD)	0
Skewness	4.473596523
Sum	30409
Variance	0.2911522111

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	147605	86.8%
1	17063	10.0%
2	3679	2.2%
3	1096	0.6%
4	357	0.2%
5	138	0.1%
6	47	< 0.1%
7	22	< 0.1%
8	8	< 0.1%
9	3	< 0.1%
Other values (3)	5	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	147605	86.8%
1	17063	10.0%
2	3679	2.2%
3	1096	0.6%
4	357	0.2%

Value	Count	Frequency (%)
13	1	< 0.1%
11	2	< 0.1%
10	2	< 0.1%
9	3	< 0.1%
8	8	< 0.1%

INJURIES_FATAL
Categorical

Distinct count	4
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

0	169936
1	82
2	4
3	1

Common Values
Length

Value	Count	Frequency (%)
0	169936	99.9%
1	82	< 0.1%
2	4	< 0.1%
3	1	< 0.1%

Length

Max length	3
Median length	3
Mean length	3
Min length	3

INJURIES_INCAPACITATING
Real number (ℝ_≥0)

ZEROS

Distinct count	6
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.018891561729883603
Minimum	0.0
Maximum	5.0
Zeros	167295
Zeros (%)	98.4%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	5
Range	5
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.1619503063
Coefficient of variation (CV)	8.572626689
Kurtosis	173.3193565
Mean	0.01889156173
Median Absolute Deviation (MAD)	0
Skewness	11.30760395
Sum	3212
Variance	0.02622790171

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	167295	98.4%
1	2375	1.4%
2	256	0.2%
3	68	< 0.1%
4	24	< 0.1%
5	5	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	167295	98.4%
1	2375	1.4%
2	256	0.2%
3	68	< 0.1%
4	24	< 0.1%

Value	Count	Frequency (%)
5	5	< 0.1%
4	24	< 0.1%
3	68	< 0.1%
2	256	0.2%
1	2375	1.4%

INJURIES_NON_INCAPACITATING
Real number (ℝ_≥0)

ZEROS

Distinct count	11
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.09533416067237963
Minimum	0.0
Maximum	11.0
Zeros	157578
Zeros (%)	92.7%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	11
Range	11
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.3921160241
Coefficient of variation (CV)	4.113069453
Kurtosis	58.02302948
Mean	0.09533416067
Median Absolute Deviation (MAD)	0
Skewness	6.119044588
Sum	16209
Variance	0.1537549764

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	157578	92.7%
1	9906	5.8%
2	1758	1.0%
3	507	0.3%
4	177	0.1%
5	57	< 0.1%
6	22	< 0.1%
7	11	< 0.1%
8	4	< 0.1%
11	2	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	157578	92.7%
1	9906	5.8%
2	1758	1.0%
3	507	0.3%
4	177	0.1%

Value	Count	Frequency (%)
11	2	< 0.1%
10	1	< 0.1%
8	4	< 0.1%
7	11	< 0.1%
6	22	< 0.1%

INJURIES_REPORTED_NOT_EVIDENT
Real number (ℝ_≥0)

ZEROS

Distinct count	11
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.06407956570581627
Minimum	0.0
Maximum	10.0
Zeros	161617
Zeros (%)	95.1%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	10
Range	10
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.3201525205
Coefficient of variation (CV)	4.996171821
Kurtosis	75.43556623
Mean	0.06407956571
Median Absolute Deviation (MAD)	0
Skewness	7.137627663
Sum	10895
Variance	0.1024976364

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	161617	95.1%
1	6647	3.9%
2	1275	0.7%
3	330	0.2%
4	94	0.1%
5	43	< 0.1%
6	9	< 0.1%
7	4	< 0.1%
8	2	< 0.1%
9	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	161617	95.1%
1	6647	3.9%
2	1275	0.7%
3	330	0.2%
4	94	0.1%

Value	Count	Frequency (%)
10	1	< 0.1%
9	1	< 0.1%
8	2	< 0.1%
7	4	< 0.1%
6	9	< 0.1%

INJURIES_NO_INDICATION
Real number (ℝ_≥0)

ZEROS

Distinct count	19
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.1724119677925926
Minimum	0.0
Maximum	19.0
Zeros	2783
Zeros (%)	1.6%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	2
Q3	2
95-th percentile	4
Maximum	19
Range	19
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.107867356
Coefficient of variation (CV)	0.5099711163
Kurtosis	10.11862197
Mean	2.172411968
Median Absolute Deviation (MAD)	0
Skewness	2.054233066
Sum	369360
Variance	1.227370079

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2	92726	54.5%
1	33734	19.8%
3	24807	14.6%
4	9305	5.5%
5	3846	2.3%
0	2783	1.6%
6	1641	1.0%
7	640	0.4%
8	280	0.2%
9	118	0.1%
Other values (9)	143	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2783	1.6%
1	33734	19.8%
2	92726	54.5%
3	24807	14.6%
4	9305	5.5%

Value	Count	Frequency (%)
19	1	< 0.1%
17	4	< 0.1%
16	8	< 0.1%
15	4	< 0.1%
14	12	< 0.1%

CRASH_HOUR
Real number (ℝ_≥0)

ZEROS

Distinct count	24
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	13.280756132993771
Minimum	0.0
Maximum	23.0
Zeros	2664
Zeros (%)	1.6%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	4
Q1	9
median	14
Q3	17
95-th percentile	21
Maximum	23
Range	23
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	5.257633647
Coefficient of variation (CV)	0.3958836074
Kurtosis	-0.347998741
Mean	13.28075613
Median Absolute Deviation (MAD)	4
Skewness	-0.3704724486
Sum	2258034
Variance	27.64271157

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
16	13622	8.0%
15	13502	7.9%
17	13247	7.8%
14	11804	6.9%
18	10641	6.3%
13	10495	6.2%
8	10445	6.1%
12	9932	5.8%
11	8779	5.2%
7	8503	5.0%
Other values (14)	59053	34.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2664	1.6%
1	2148	1.3%
2	1932	1.1%
3	1563	0.9%
4	1490	0.9%

Value	Count	Frequency (%)
23	3747	2.2%
22	4585	2.7%
21	5116	3.0%
20	5854	3.4%
19	7477	4.4%

CRASH_DAY_OF_WEEK
Real number (ℝ_≥0)

Distinct count	7
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4.143574692835675
Minimum	1.0
Maximum	7.0
Zeros	0
Zeros (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	7
Maximum	7
Range	6
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	1.943718512
Coefficient of variation (CV)	0.4690921864
Kurtosis	-1.20505114
Mean	4.143574693
Median Absolute Deviation (MAD)	2
Skewness	-0.08342100232
Sum	704503
Variance	3.778041654

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
6	28091	16.5%
5	25247	14.8%
4	24911	14.7%
3	24904	14.6%
7	24133	14.2%
2	23698	13.9%
1	19039	11.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	19039	11.2%
2	23698	13.9%
3	24904	14.6%
4	24911	14.7%
5	25247	14.8%

Value	Count	Frequency (%)
7	24133	14.2%
6	28091	16.5%
5	25247	14.8%
4	24911	14.7%
3	24904	14.6%

CRASH_MONTH
Real number (ℝ_≥0)

Distinct count	12
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	6.630979338089553
Minimum	1.0
Maximum	12.0
Zeros	0
Zeros (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	7
Q3	10
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.497311421
Coefficient of variation (CV)	0.527420045
Kurtosis	-1.249054291
Mean	6.630979338
Median Absolute Deviation (MAD)	3
Skewness	-0.04830946728
Sum	1127419
Variance	12.23118717

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
10	15814	9.3%
12	15531	9.1%
11	15050	8.9%
5	14807	8.7%
9	14395	8.5%
1	14149	8.3%
3	13782	8.1%
6	13712	8.1%
8	13616	8.0%
2	13602	8.0%
Other values (2)	25565	15.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	14149	8.3%
2	13602	8.0%
3	13782	8.1%
4	13029	7.7%
5	14807	8.7%

Value	Count	Frequency (%)
12	15531	9.1%
11	15050	8.9%
10	15814	9.3%
9	14395	8.5%
8	13616	8.0%

LATITUDE
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct count	93791
Unique (%)	55.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	41.85832423734304
Minimum	0.0
Maximum	42.022779861
Zeros	17
Zeros (%)	< 0.1%
Memory size	1.3 MiB

Quantile statistics

Minimum	0
5-th percentile	41.71524485
Q1	41.78958119
median	41.87944196
Q3	41.92768648
95-th percentile	41.99054486
Maximum	42.02277986
Range	42.02277986
Interquartile range (IQR)	0.138105291

Descriptive statistics

Standard deviation	0.4271946112
Coefficient of variation (CV)	0.01020572656
Kurtosis	9213.872316
Mean	41.85832424
Median Absolute Deviation (MAD)	0.066371257
Skewness	-94.06388966
Sum	7116877.862
Variance	0.1824952359

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
41.97620114	212	0.1%
41.7514606	112	0.1%
41.90095892	108	0.1%
41.79142028	107	0.1%
41.72225727	85	< 0.1%
41.90100286	74	< 0.1%
41.78932932	74	< 0.1%
41.75466012	70	< 0.1%
41.73620947	67	< 0.1%
41.79291088	65	< 0.1%
Other values (93781)	169049	99.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	17	< 0.1%
41.64467013	4	< 0.1%
41.64469397	2	< 0.1%
41.64471544	1	< 0.1%
41.64471877	1	< 0.1%

Value	Count	Frequency (%)
42.02277986	2	< 0.1%
42.02266114	2	< 0.1%
42.02264514	1	< 0.1%
42.02264168	1	< 0.1%
42.02255132	1	< 0.1%

LONGITUDE
Real number (ℝ)

HIGH CORRELATION
SKEWED

Distinct count	93787
Unique (%)	55.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-87.67070524713213
Minimum	-87.934014222
Maximum	0.0
Zeros	17
Zeros (%)	< 0.1%
Memory size	1.3 MiB

Quantile statistics

Minimum	-87.93401422
5-th percentile	-87.78188205
Q1	-87.72230714
median	-87.67272966
Q3	-87.63315544
95-th percentile	-87.58762602
Maximum	0
Range	87.93401422
Interquartile range (IQR)	0.089151695

Descriptive statistics

Standard deviation	0.8786550779
Coefficient of variation (CV)	-0.0100222198
Kurtosis	9907.679574
Mean	-87.67070525
Median Absolute Deviation (MAD)	0.042582218
Skewness	99.32443394
Sum	-14906036.32
Variance	0.7720347459

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
-87.90530913	212	0.1%
-87.58597199	112	0.1%
-87.61992817	108	0.1%
-87.58014777	107	0.1%
-87.58527557	85	< 0.1%
-87.74164564	74	< 0.1%
-87.61977981	74	< 0.1%
-87.74138476	70	< 0.1%
-87.62430552	67	< 0.1%
-87.74207734	65	< 0.1%
Other values (93777)	169049	99.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-87.93401422	1	< 0.1%
-87.93399393	10	< 0.1%
-87.93302828	2	< 0.1%
-87.92726168	2	< 0.1%
-87.92503562	1	< 0.1%

Value	Count	Frequency (%)
0	17	< 0.1%
-87.52458739	1	< 0.1%
-87.52458901	1	< 0.1%
-87.52464032	1	< 0.1%
-87.52467395	2	< 0.1%

STREET_TYPE
Categorical

Distinct count	15
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

AVE	85561
ST	51625
RD	11639
DR	6561
BLVD	6163
Other values (10)	8474

Common Values
Length

Value	Count	Frequency (%)
AVE	85561	50.3%
ST	51625	30.4%
RD	11639	6.8%
DR	6561	3.9%
BLVD	6163	3.6%
NB	1556	0.9%
SB	1484	0.9%
PL	1300	0.8%
PKWY	1202	0.7%
BROADWAY	933	0.5%
Other values (5)	1999	1.2%

Length

Max length	8
Median length	3
Mean length	2.631173429
Min length	1

TRAFFIC_CONTROL_PRESENT
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

0	88229
1	81794

Frequency Table

Value	Count	Frequency (%)
0	88229	51.9%
1	81794	48.1%

STRAIGHT_ROAD
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

1	168234
0	1789

Frequency Table

Value	Count	Frequency (%)
1	168234	98.9%
0	1789	1.1%

LEVEL_ROAD
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

1	166678
0	3345

Frequency Table

Value	Count	Frequency (%)
1	166678	98.0%
0	3345	2.0%

TIME_BEFORE_NOTIFICATION
Real number (ℝ_≥0)

Distinct count	1179
Unique (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	93.18010504461161
Minimum	2.0000000000000004
Maximum	1182.0
Zeros	0
Zeros (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	2
5-th percentile	2
Q1	9
median	28
Q3	69
95-th percentile	550
Maximum	1182
Range	1180
Interquartile range (IQR)	60

Descriptive statistics

Standard deviation	196.7186373
Coefficient of variation (CV)	2.111165652
Kurtosis	12.82761221
Mean	93.18010504
Median Absolute Deviation (MAD)	23
Skewness	3.551872939
Sum	15842761
Variance	38698.22225

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
5	12259	7.2%
2	8899	5.2%
10	7590	4.5%
30	7510	4.4%
15	7273	4.3%
3	6682	3.9%
20	6100	3.6%
4	5490	3.2%
25	4225	2.5%
60	3868	2.3%
Other values (1169)	100127	58.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	8899	5.2%
3	6682	3.9%
4	5490	3.2%
5	12259	7.2%
6	3634	2.1%

Value	Count	Frequency (%)
1182	8	< 0.1%
1181	5	< 0.1%
1180	52	< 0.1%
1179	1	< 0.1%
1178	9	< 0.1%

LANE_TYPE
Categorical

MISSING

Distinct count	4
Unique (%)	< 0.1%
Missing	81976
Missing (%)	48.2%
Memory size	166.2 KiB

small	51328
medium	29712
large	3538
intersection	3469

Common Values
Length

Value	Count	Frequency (%)
small	51328	30.2%
medium	29712	17.5%
large	3538	2.1%
intersection	3469	2.0%
(Missing)	81976	48.2%

Length

Max length	12
Median length	5
Mean length	4.353281615
Min length	3

MAIN_CAUSE
Categorical

HIGH CORRELATION

Distinct count	6
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

Driver Error	152302
Weather	5003
Driver/Equip/RD Health	4546
Driver Distraction	4230
Road/Vision Obstruction	2597

Common Values
Length

Value	Count	Frequency (%)
Driver Error	152302	89.6%
Weather	5003	2.9%
Driver/Equip/RD Health	4546	2.7%
Driver Distraction	4230	2.5%
Road/Vision Obstruction	2597	1.5%
Drug Use	1345	0.8%

Length

Max length	23
Median length	12
Mean length	12.40589803
Min length	7

TOTAL_PEOPLE_INVOLVED
Real number (ℝ_≥0)

Distinct count	19
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.351264240720373
Minimum	1.0
Maximum	19.0
Zeros	0
Zeros (%)	0.0%
Memory size	1.3 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	2
Q3	3
95-th percentile	4
Maximum	19
Range	18
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.116056721
Coefficient of variation (CV)	0.4746623974
Kurtosis	11.08803208
Mean	2.351264241
Median Absolute Deviation (MAD)	0
Skewness	2.357585749
Sum	399769
Variance	1.245582605

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2	99045	58.3%
3	28360	16.7%
1	23022	13.5%
4	11161	6.6%
5	4776	2.8%
6	2100	1.2%
7	855	0.5%
8	362	0.2%
9	156	0.1%
10	77	< 0.1%
Other values (9)	109	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	23022	13.5%
2	99045	58.3%
3	28360	16.7%
4	11161	6.6%
5	4776	2.8%

Value	Count	Frequency (%)
19	1	< 0.1%
18	1	< 0.1%
17	4	< 0.1%
16	8	< 0.1%
15	4	< 0.1%

DRY_ROAD
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

1	128493
0	41530

Frequency Table

Value	Count	Frequency (%)
1	128493	75.6%
0	41530	24.4%

CLEAR_WEATHER
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

1	135513
0	34510

Frequency Table

Value	Count	Frequency (%)
1	135513	79.7%
0	34510	20.3%

DRIVER_ERROR
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

1	152302
0	17721

Frequency Table

Value	Count	Frequency (%)
1	152302	89.6%
0	17721	10.4%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

First rows

	df_index	CRASH_RECORD_ID	RD_NO	POSTED_SPEED_LIMIT	TRAFFIC_CONTROL_DEVICE	DEVICE_CONDITION	WEATHER_CONDITION	LIGHTING_CONDITION	FIRST_CRASH_TYPE	TRAFFICWAY_TYPE	ROADWAY_SURFACE_COND	ROAD_DEFECT	REPORT_TYPE	CRASH_TYPE	HIT_AND_RUN_I	DAMAGE	PRIM_CONTRIBUTORY_CAUSE	SEC_CONTRIBUTORY_CAUSE	STREET_NO	STREET_DIRECTION	STREET_NAME	BEAT_OF_OCCURRENCE	NUM_UNITS	INJURIES_NO_INDICATION	CRASH_HOUR	CRASH_DAY_OF_WEEK	CRASH_MONTH	LATITUDE	LONGITUDE	STREET_TYPE	TRAFFIC_CONTROL_PRESENT	STRAIGHT_ROAD	LEVEL_ROAD	TIME_BEFORE_NOTIFICATION	LANE_TYPE	MAIN_CAUSE	TOTAL_PEOPLE_INVOLVED	DRY_ROAD	CLEAR_WEATHER	DRIVER_ERROR
0	6	0209e21f298984f7375742b7ef27c9880b485f41123a12b5a8eb14f01171abbbc05974399b985e05a352f801869cae0f41587f39a51994338fb82aeba853eece	JB415436	30.0	TRAFFIC SIGNAL	FUNCTIONING PROPERLY	CLEAR	DAYLIGHT	TURNING	NOT DIVIDED	DRY	UNKNOWN	NOT ON SCENE (DESK REPORT)	NO INJURY / DRIVE AWAY	0.0	OVER $1,500	IMPROPER OVERTAKING/PASSING	IMPROPER LANE USAGE	600.0	W	DIVISION ST	1822.0	2.0	2.0	17.0	5.0	8.0	41.903825	-87.643286	ST	1.0	1.0	1.0	13.0	NaN	Driver Error	2.0	1	1	1
1	8	02e2ed3606a50dda185f5e97c57a45552087d6fbea1c4b5f3777e0503da72279211f0518aabbeca2cd8e8ee1aca6cae3f88a0531cb62bb39ac156ca3d55e0931	JB256393	25.0	NO CONTROLS	NO CONTROLS	RAIN	DAYLIGHT	ANGLE	NOT DIVIDED	WET	NO DEFECTS	ON SCENE	NO INJURY / DRIVE AWAY	0.0	OVER $1,500	FAILING TO YIELD RIGHT-OF-WAY	UNABLE TO DETERMINE	9511.0	S	WENTWORTH AVE	511.0	2.0	2.0	11.0	4.0	5.0	41.721290	-87.628510	AVE	0.0	1.0	1.0	5.0	small	Driver Error	2.0	0	0	1
2	11	046c0f96fdf5f7384e026821bb23fdd56d610dce11247b4cf7072f4e0308cdf5865ee8f31d71792ef005d864c064aae933213ef5e4e87a9bb2247ffe0f56f245	JC128226	30.0	NO CONTROLS	NO CONTROLS	CLEAR	DARKNESS, LIGHTED ROAD	REAR END	DIVIDED - W/MEDIAN BARRIER	WET	NO DEFECTS	NOT ON SCENE (DESK REPORT)	NO INJURY / DRIVE AWAY	0.0	OVER $1,500	EXCEEDING SAFE SPEED FOR CONDITIONS	FOLLOWING TOO CLOSELY	50.0	E	GARFIELD BLVD	225.0	2.0	2.0	6.0	5.0	1.0	41.794779	-87.623828	BLVD	0.0	1.0	1.0	535.0	medium	Driver Error	2.0	0	1	1
3	12	04f6245394966ed41b109ac46b18ed45b8b90c6607cebc99008d9a733b4b668d4effab8de602f2ed17854835b5efce5d76701c8d97d25c23c9814ee9e63e7a60	JB258516	30.0	STOP SIGN/FLASHER	FUNCTIONING PROPERLY	CLEAR	DAYLIGHT	REAR END	ONE-WAY	DRY	NO DEFECTS	NOT ON SCENE (DESK REPORT)	NO INJURY / DRIVE AWAY	1.0	$501 - $1,500	IMPROPER BACKING	NOT APPLICABLE	180.0	W	SCHILLER ST	1821.0	2.0	3.0	18.0	5.0	5.0	41.907777	-87.634531	ST	1.0	1.0	1.0	40.0	small	Driver Error	3.0	1	1	1
4	13	0564e565ebda939c88d5da6d613ac5789b702cbff5b8744552f9930bd571995afb81a895dfd2bc8a23e6cca53f8fc6a9afbeb38591781281a3c37ceba5cbcbd5	JC541936	20.0	TRAFFIC SIGNAL	FUNCTIONING PROPERLY	CLEAR	DAYLIGHT	PEDESTRIAN	NOT DIVIDED	DRY	NO DEFECTS	NOT ON SCENE (DESK REPORT)	NO INJURY / DRIVE AWAY	0.0	$500 OR LESS	DISTRACTION - FROM INSIDE VEHICLE	DISTRACTION - FROM INSIDE VEHICLE	3998.0	N	ASHLAND AVE	1922.0	2.0	2.0	15.0	3.0	12.0	41.954196	-87.669193	AVE	1.0	1.0	1.0	5.0	NaN	Driver Distraction	2.0	1	1	0
5	14	05a2558531eb0174cb4d8ec5de92fdc94c1894b31923fdbb09f62e41a1eb3716ca641b84c64b6b5dd442cd4f1214eb061318d37154d66d03fb59056987645db7	JA116988	30.0	NO CONTROLS	NO CONTROLS	CLEAR	DAYLIGHT	SIDESWIPE SAME DIRECTION	DIVIDED - W/MEDIAN (NOT RAISED)	DRY	NO DEFECTS	NOT ON SCENE (DESK REPORT)	NO INJURY / DRIVE AWAY	0.0	OVER $1,500	IMPROPER LANE USAGE	NOT APPLICABLE	117.0	W	NORTH AVE	1821.0	2.0	4.0	14.0	1.0	1.0	41.911051	-87.632436	AVE	0.0	1.0	1.0	20.0	medium	Driver Error	4.0	1	1	1
6	15	064e66979a2970426924a31edac09282c4ede65aad5827ab5bf314b0c5404ddb82dfd349d1df97f7cdd42fa48054021295a7b5b9f873cf77a8ae5b506516ba24	JA162887	30.0	TRAFFIC SIGNAL	FUNCTIONING PROPERLY	CLOUDY/OVERCAST	DAYLIGHT	TURNING	DIVIDED - W/MEDIAN (NOT RAISED)	WET	NO DEFECTS	ON SCENE	NO INJURY / DRIVE AWAY	0.0	OVER $1,500	IMPROPER OVERTAKING/PASSING	FAILING TO REDUCE SPEED TO AVOID CRASH	2101.0	S	ASHLAND AVE	1235.0	2.0	3.0	7.0	4.0	2.0	41.854120	-87.665902	AVE	1.0	1.0	1.0	4.0	intersection	Driver Error	3.0	0	0	1
7	18	0715747ad03659bf4f8c41699d349d805c0a8863e7033c7f0dd4b6232d2ab96f5c7d161d9f944f4919f1d16520d6f9ebe8fe3d9175212d0f011ee4bf9137b38e	HZ485307	30.0	STOP SIGN/FLASHER	FUNCTIONING PROPERLY	CLEAR	DARKNESS, LIGHTED ROAD	ANGLE	NOT DIVIDED	DRY	NO DEFECTS	ON SCENE	NO INJURY / DRIVE AWAY	0.0	OVER $1,500	FAILING TO YIELD RIGHT-OF-WAY	DISREGARDING STOP SIGN	2000.0	W	ERIE ST	1221.0	2.0	3.0	3.0	1.0	10.0	41.893281	-87.677100	ST	1.0	1.0	1.0	3.0	small	Driver Error	3.0	1	1	1
8	20	07cf8b845534957256f1c0dafd4f95c08037233f3d367db726f9f56686ec31ce7bc3f24e350ae9d93cde2387a6606093775ac87dfb78685050e5ef0f096f67c9	JB237031	30.0	TRAFFIC SIGNAL	FUNCTIONING PROPERLY	CLEAR	DAYLIGHT	REAR END	NOT DIVIDED	DRY	NO DEFECTS	NOT ON SCENE (DESK REPORT)	NO INJURY / DRIVE AWAY	0.0	OVER $1,500	FOLLOWING TOO CLOSELY	DRIVING SKILLS/KNOWLEDGE/EXPERIENCE	11.0	S	AUSTIN BLVD	1513.0	2.0	2.0	18.0	3.0	4.0	41.879714	-87.774496	BLVD	1.0	1.0	1.0	800.0	NaN	Driver Error	2.0	1	1	1
9	21	097eb95ff3e26f44b8ae8f38890128a3ca6158d1cd41f5a3fcb2491b1cac2eb87ad2d281f493e3200223480a6cfbe09e014466bb06428a512ffbd3c84c42d677	JA454982	30.0	OTHER	NO CONTROLS	CLEAR	DAYLIGHT	SIDESWIPE SAME DIRECTION	NOT DIVIDED	DRY	NO DEFECTS	NOT ON SCENE (DESK REPORT)	NO INJURY / DRIVE AWAY	0.0	OVER $1,500	IMPROPER LANE USAGE	NOT APPLICABLE	9505.0	S	HALSTED ST	2223.0	2.0	2.0	8.0	2.0	10.0	41.721256	-87.643062	ST	1.0	1.0	1.0	95.0	NaN	Driver Error	2.0	1	1	1

Last rows

	df_index	CRASH_RECORD_ID	RD_NO	POSTED_SPEED_LIMIT	TRAFFIC_CONTROL_DEVICE	DEVICE_CONDITION	WEATHER_CONDITION	LIGHTING_CONDITION	FIRST_CRASH_TYPE	TRAFFICWAY_TYPE	ROADWAY_SURFACE_COND	ROAD_DEFECT	REPORT_TYPE	CRASH_TYPE	HIT_AND_RUN_I	DAMAGE	PRIM_CONTRIBUTORY_CAUSE	SEC_CONTRIBUTORY_CAUSE	STREET_NO	STREET_DIRECTION	STREET_NAME	BEAT_OF_OCCURRENCE	NUM_UNITS	INJURIES_NO_INDICATION	CRASH_HOUR	CRASH_DAY_OF_WEEK	CRASH_MONTH	LATITUDE	LONGITUDE	STREET_TYPE	TRAFFIC_CONTROL_PRESENT	STRAIGHT_ROAD	LEVEL_ROAD	TIME_BEFORE_NOTIFICATION	LANE_TYPE	MAIN_CAUSE	TOTAL_PEOPLE_INVOLVED	DRY_ROAD	CLEAR_WEATHER	DRIVER_ERROR
170013	416170	1a3386e6a23e96e01acff8acf0ef1b3e7356197c38e2422162e1d6f75c508a39d017a5d6248b4172c02a935c7e64f540a1e9c2432b67c86e9f795f64f3eff849	JD236846	30.0	NO CONTROLS	NO CONTROLS	CLEAR	DAYLIGHT	TURNING	NOT DIVIDED	WET	UNKNOWN	ON SCENE	NO INJURY / DRIVE AWAY	1.0	OVER $1,500	FAILING TO YIELD RIGHT-OF-WAY	NOT APPLICABLE	2718.0	W	FOSTER AVE	2011.0	2.0	3.0	16.0	3.0	5.0	41.975941	-87.697289	AVE	0.0	1.0	1.0	10.0	NaN	Driver Error	3.0	0	1	1
170014	416172	16acabdfcfa055f2e7760b288b67d37c4b2f8564d1eaa1b08abd5de7707e5c56cb5c06fd9034d3492ff2c81bc0ee07bdcff61771b03b2948689c153041c278ac	JD236417	25.0	NO CONTROLS	NO CONTROLS	RAIN	DARKNESS, LIGHTED ROAD	SIDESWIPE SAME DIRECTION	NOT DIVIDED	WET	NO DEFECTS	NOT ON SCENE (DESK REPORT)	NO INJURY / DRIVE AWAY	1.0	$501 - $1,500	IMPROPER LANE USAGE	NOT APPLICABLE	7159.0	S	NORMAL BLVD	732.0	2.0	2.0	0.0	3.0	5.0	41.763587	-87.636913	BLVD	0.0	1.0	1.0	570.0	NaN	Driver Error	2.0	0	0	1
170015	416173	001eecabb8448be837995caca46a221c62245ece1ad580ef77e572be61a030bb614fb67f69f0add17e5e043d4034a88b1cca656c0de307853e7cae281e222a8c	JD236720	30.0	NO CONTROLS	NO CONTROLS	FOG/SMOKE/HAZE	DAYLIGHT	REAR END	NOT DIVIDED	WET	NO DEFECTS	NOT ON SCENE (DESK REPORT)	NO INJURY / DRIVE AWAY	0.0	$501 - $1,500	FOLLOWING TOO CLOSELY	FAILING TO REDUCE SPEED TO AVOID CRASH	2159.0	N	HARLEM AVE	2512.0	2.0	2.0	14.0	3.0	5.0	41.919767	-87.805972	AVE	0.0	1.0	1.0	61.0	NaN	Driver Error	2.0	0	0	1
170016	416174	0c3ec565fd94621168dccbfd0a95097d0d96ab27241bfee94e818ce7a02c812e70f3ec53d4565670b568ab56ea4a9d6a8d88e18820ec5185f00f004f42147d37	JD236827	30.0	NO CONTROLS	NO CONTROLS	CLEAR	DAYLIGHT	SIDESWIPE SAME DIRECTION	NOT DIVIDED	DRY	NO DEFECTS	NOT ON SCENE (DESK REPORT)	NO INJURY / DRIVE AWAY	0.0	$501 - $1,500	FOLLOWING TOO CLOSELY	NOT APPLICABLE	500.0	S	CENTRAL AVE	1513.0	2.0	2.0	16.0	3.0	5.0	41.873773	-87.764770	AVE	0.0	1.0	1.0	20.0	NaN	Driver Error	2.0	1	1	1
170017	416182	ee451349ec959d73cb77c87e2bcfda6bbd378bcd74421660d3c204762dba12bd6a0738c90289e441e6b804060f61a1e4e434a6d62c047308fa3346afc324e2c7	JD236776	25.0	TRAFFIC SIGNAL	FUNCTIONING PROPERLY	CLEAR	DAYLIGHT	ANGLE	FOUR WAY	WET	NO DEFECTS	ON SCENE	NO INJURY / DRIVE AWAY	1.0	OVER $1,500	DISREGARDING TRAFFIC SIGNALS	UNABLE TO DETERMINE	5032.0	N	CLARK ST	2032.0	2.0	2.0	14.0	3.0	5.0	41.973359	-87.668224	ST	1.0	1.0	1.0	5.0	NaN	Driver Error	2.0	0	1	1
170018	416184	e450bca25335c1278ea2363381ecc508ebd53e5c56674707122b665be54927fd0c49eebe9d98a1f14a95983f1933e726b107399f9436754191e6e1def6e90535	JD235006	30.0	NO CONTROLS	NO CONTROLS	RAIN	DAWN	PARKED MOTOR VEHICLE	DIVIDED - W/MEDIAN (NOT RAISED)	WET	NO DEFECTS	NOT ON SCENE (DESK REPORT)	NO INJURY / DRIVE AWAY	0.0	OVER $1,500	IMPROPER BACKING	NOT APPLICABLE	3604.0	N	CENTRAL PARK AVE	1732.0	2.0	1.0	13.0	1.0	5.0	41.947062	-87.717972	AVE	0.0	1.0	1.0	52.0	NaN	Driver Error	1.0	0	0	1
170019	416185	d0a818ec05c4314c5f56b82c0590fd98686aeaf01e04756cabb424d171534fbf8adaa91a7560832d82dc0b733466568c498bc900022a3429990bcb190ab51509	JD235373	30.0	NO CONTROLS	NO CONTROLS	CLEAR	DARKNESS, LIGHTED ROAD	PARKED MOTOR VEHICLE	NOT DIVIDED	DRY	NO DEFECTS	ON SCENE	INJURY AND / OR TOW DUE TO CRASH	0.0	OVER $1,500	DISTRACTION - FROM OUTSIDE VEHICLE	DISTRACTION - FROM OUTSIDE VEHICLE	6747.0	W	BELMONT AVE	2511.0	2.0	1.0	0.0	2.0	5.0	41.938057	-87.795161	AVE	0.0	1.0	1.0	2.0	NaN	Driver Distraction	1.0	1	1	0
170020	416187	dba8fb67b8cfd7b0d1da3b9f03eccf574edd2835101419c4cbfa728e9d75673d138879354351927fb5fafcd6210bf19c503f66c9e0644a61ece7c333c0bf44ea	JD236770	30.0	TRAFFIC SIGNAL	FUNCTIONING PROPERLY	CLEAR	DAYLIGHT	SIDESWIPE SAME DIRECTION	NOT DIVIDED	DRY	NO DEFECTS	NOT ON SCENE (DESK REPORT)	NO INJURY / DRIVE AWAY	0.0	OVER $1,500	IMPROPER LANE USAGE	NOT APPLICABLE	1440.0	N	ASHLAND AVE	1433.0	2.0	2.0	14.0	3.0	5.0	41.908249	-87.667768	AVE	1.0	1.0	1.0	45.0	NaN	Driver Error	2.0	1	1	1
170021	416191	d97477e587b8eecbdb0dbce0a0c5462e7335a4f7da2e04c8e4799193cba69f0b887de56a831e8899031c1f7175e82a2ad8c43ba34260181a3e4e1bafda37ea88	JD234027	40.0	NO CONTROLS	NO CONTROLS	CLEAR	DAYLIGHT	SIDESWIPE SAME DIRECTION	DIVIDED - W/MEDIAN BARRIER	DRY	NO DEFECTS	ON SCENE	INJURY AND / OR TOW DUE TO CRASH	0.0	OVER $1,500	FAILING TO YIELD RIGHT-OF-WAY	NOT APPLICABLE	120.0	N	LAKE SHORE DR SB	114.0	2.0	2.0	11.0	7.0	5.0	41.883642	-87.615441	SB	0.0	0.0	1.0	10.0	NaN	Driver Error	2.0	1	1	1
170022	416193	de4cbde297443228427759c6d58f40254dc8d8fcb201dc731da85d4d0dcd05fd2fbb10974bc0d17cdecd4128959af5b2fc2a4b8a0ee42f3370be201aba68a5bd	JD235651	10.0	NO CONTROLS	NO CONTROLS	CLEAR	DAYLIGHT	REAR TO SIDE	PARKING LOT	DRY	NO DEFECTS	NOT ON SCENE (DESK REPORT)	NO INJURY / DRIVE AWAY	0.0	$500 OR LESS	FAILING TO YIELD RIGHT-OF-WAY	UNABLE TO DETERMINE	1527.0	W	LAWRENCE AVE	1912.0	2.0	2.0	12.0	2.0	5.0	41.968773	-87.668624	AVE	0.0	1.0	1.0	12.0	NaN	Driver Error	2.0	1	1	1

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows